{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "data/落户公示1.htm\n",
      "data/落户公示2.htm\n",
      "data/落户公示3.htm\n",
      "data/落户公示4.htm\n",
      "data/落户公示5.htm\n",
      "data/落户公示6.htm\n",
      "data/落户公示7.htm\n",
      "data/落户公示8.htm\n",
      "data/落户公示9.htm\n",
      "data/落户公示10.htm\n",
      "data/落户公示11.htm\n",
      "data/落户公示12.htm\n",
      "data/落户公示13.htm\n",
      "data/落户公示14.htm\n",
      "data/落户公示15.htm\n",
      "data/落户公示16.htm\n",
      "data/落户公示17.htm\n",
      "data/落户公示18.htm\n",
      "data/落户公示19.htm\n",
      "data/落户公示20.htm\n",
      "data/落户公示21.htm\n",
      "data/落户公示22.htm\n",
      "data/落户公示23.htm\n",
      "data/落户公示24.htm\n",
      "data/落户公示25.htm\n",
      "data/落户公示26.htm\n",
      "data/落户公示27.htm\n",
      "data/落户公示28.htm\n",
      "data/落户公示29.htm\n",
      "data/落户公示30.htm\n",
      "data/落户公示31.htm\n",
      "data/落户公示32.htm\n",
      "data/落户公示33.htm\n",
      "data/落户公示34.htm\n",
      "data/落户公示35.htm\n",
      "data/落户公示36.htm\n",
      "data/落户公示37.htm\n",
      "data/落户公示38.htm\n",
      "data/落户公示39.htm\n",
      "data/落户公示40.htm\n",
      "data/落户公示41.htm\n",
      "data/落户公示42.htm\n",
      "data/落户公示43.htm\n",
      "data/落户公示44.htm\n",
      "data/落户公示45.htm\n",
      "data/落户公示46.htm\n",
      "data/落户公示47.htm\n",
      "data/落户公示48.htm\n",
      "data/落户公示49.htm\n",
      "data/落户公示50.htm\n",
      "data/落户公示51.htm\n",
      "data/落户公示52.htm\n",
      "data/落户公示53.htm\n",
      "data/落户公示54.htm\n",
      "data/落户公示55.htm\n",
      "data/落户公示56.htm\n",
      "data/落户公示57.htm\n",
      "data/落户公示58.htm\n",
      "data/落户公示59.htm\n",
      "data/落户公示60.htm\n",
      "data/落户公示61.htm\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "def read_data(filename):\n",
    "    print(filename)\n",
    "    raw_dfs = pd.read_html(filename)\n",
    "    return raw_dfs[1]\n",
    "dfs = []\n",
    "for i in range(1, 62):\n",
    "    dfs.append(read_data('data/落户公示%d.htm'%i))\n",
    "df = pd.concat(dfs)\n",
    "df['year'] = [int(a.split('-')[0]) for a in df['出生年月']]\n",
    "df['age'] = 2019-df['year']\n",
    "df.index = df['序号']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>序号</th>\n",
       "      <th>姓名</th>\n",
       "      <th>出生年月</th>\n",
       "      <th>单位名称</th>\n",
       "      <th>积分分值</th>\n",
       "      <th>year</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>序号</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>朱虹</td>\n",
       "      <td>1978-11</td>\n",
       "      <td>中央电视台</td>\n",
       "      <td>125.79</td>\n",
       "      <td>1978</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>胡瑾</td>\n",
       "      <td>1977-12</td>\n",
       "      <td>北京安御道合科技有限公司</td>\n",
       "      <td>124.49</td>\n",
       "      <td>1977</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>熊海平</td>\n",
       "      <td>1972-10</td>\n",
       "      <td>北京融信通金服科技股份有限公司</td>\n",
       "      <td>120.33</td>\n",
       "      <td>1972</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>程刚</td>\n",
       "      <td>1975-01</td>\n",
       "      <td>北京清水爱派建筑设计股份有限公司</td>\n",
       "      <td>120.00</td>\n",
       "      <td>1975</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>陈秀娟</td>\n",
       "      <td>1974-05</td>\n",
       "      <td>国网物资有限公司</td>\n",
       "      <td>119.13</td>\n",
       "      <td>1974</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>贺玉刚</td>\n",
       "      <td>1978-02</td>\n",
       "      <td>北京金蝶管理软件有限公司</td>\n",
       "      <td>119.09</td>\n",
       "      <td>1978</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>郭琳</td>\n",
       "      <td>1972-08</td>\n",
       "      <td>毕马威华振会计师事务所（特殊普通合伙）</td>\n",
       "      <td>119.00</td>\n",
       "      <td>1972</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>张静</td>\n",
       "      <td>1974-01</td>\n",
       "      <td>北京市北斗鼎铭律师事务所</td>\n",
       "      <td>117.96</td>\n",
       "      <td>1974</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>徐轶</td>\n",
       "      <td>1975-08</td>\n",
       "      <td>新世纪检验认证股份有限公司</td>\n",
       "      <td>117.20</td>\n",
       "      <td>1975</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>董国群</td>\n",
       "      <td>1972-03</td>\n",
       "      <td>北京中建地产有限责任公司</td>\n",
       "      <td>116.99</td>\n",
       "      <td>1972</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>段昌</td>\n",
       "      <td>1976-06</td>\n",
       "      <td>华为技术有限公司北京研究所</td>\n",
       "      <td>116.67</td>\n",
       "      <td>1976</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>郭斌</td>\n",
       "      <td>1972-12</td>\n",
       "      <td>北京华泰科信科技有限公司</td>\n",
       "      <td>116.67</td>\n",
       "      <td>1972</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>孔樊涌</td>\n",
       "      <td>1976-10</td>\n",
       "      <td>北京中油瑞飞信息技术有限责任公司</td>\n",
       "      <td>116.63</td>\n",
       "      <td>1976</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>罗怀梅</td>\n",
       "      <td>1976-06</td>\n",
       "      <td>北京计鹏信息咨询有限公司</td>\n",
       "      <td>116.17</td>\n",
       "      <td>1976</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>朱莉莉</td>\n",
       "      <td>1978-10</td>\n",
       "      <td>百度在线网络技术（北京）有限公司</td>\n",
       "      <td>116.00</td>\n",
       "      <td>1978</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>王中宇</td>\n",
       "      <td>1972-11</td>\n",
       "      <td>钉钉互联（北京）技术有限公司</td>\n",
       "      <td>115.96</td>\n",
       "      <td>1972</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>谢用辉</td>\n",
       "      <td>1974-09</td>\n",
       "      <td>北京新脉远望科技有限公司</td>\n",
       "      <td>115.67</td>\n",
       "      <td>1974</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>国维石</td>\n",
       "      <td>1976-03</td>\n",
       "      <td>中铁天丰建筑工程有限公司</td>\n",
       "      <td>115.63</td>\n",
       "      <td>1976</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>刘龙龙</td>\n",
       "      <td>1975-04</td>\n",
       "      <td>中央电视台</td>\n",
       "      <td>115.04</td>\n",
       "      <td>1975</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>李启武</td>\n",
       "      <td>1973-04</td>\n",
       "      <td>华泰证券股份有限公司北京月坛南街证券营业部</td>\n",
       "      <td>114.96</td>\n",
       "      <td>1973</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>梁宏旭</td>\n",
       "      <td>1976-02</td>\n",
       "      <td>北京城建北方设备安装有限责任公司</td>\n",
       "      <td>114.95</td>\n",
       "      <td>1976</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>张冬梅</td>\n",
       "      <td>1972-11</td>\n",
       "      <td>北京亿速码数据处理有限责任公司</td>\n",
       "      <td>114.79</td>\n",
       "      <td>1972</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>刘东风</td>\n",
       "      <td>1977-05</td>\n",
       "      <td>中节能清洁技术发展有限公司</td>\n",
       "      <td>114.66</td>\n",
       "      <td>1977</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>高小良</td>\n",
       "      <td>1972-12</td>\n",
       "      <td>北京中青旅海天数码科技有限公司</td>\n",
       "      <td>114.08</td>\n",
       "      <td>1972</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>郝建武</td>\n",
       "      <td>1976-07</td>\n",
       "      <td>华为技术有限公司北京研究所</td>\n",
       "      <td>113.96</td>\n",
       "      <td>1976</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>杨瑞增</td>\n",
       "      <td>1972-03</td>\n",
       "      <td>中建二局装饰工程有限公司</td>\n",
       "      <td>113.79</td>\n",
       "      <td>1972</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>何庆宁</td>\n",
       "      <td>1975-03</td>\n",
       "      <td>北京神州数码云科信息技术有限公司</td>\n",
       "      <td>113.71</td>\n",
       "      <td>1975</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>刘洋</td>\n",
       "      <td>1970-11</td>\n",
       "      <td>北京温都水城旅游饭店管理有限公司</td>\n",
       "      <td>113.46</td>\n",
       "      <td>1970</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>杨宽</td>\n",
       "      <td>1976-08</td>\n",
       "      <td>北京博睿智业人力资源顾问有限公司</td>\n",
       "      <td>113.41</td>\n",
       "      <td>1976</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>30</td>\n",
       "      <td>许畅</td>\n",
       "      <td>1973-08</td>\n",
       "      <td>西安杨森制药有限公司北京分公司</td>\n",
       "      <td>113.30</td>\n",
       "      <td>1973</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5978</th>\n",
       "      <td>5978</td>\n",
       "      <td>张晓燕</td>\n",
       "      <td>1977-07</td>\n",
       "      <td>北京三重华星电子科技有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1977</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5979</th>\n",
       "      <td>5979</td>\n",
       "      <td>甘莉</td>\n",
       "      <td>1981-11</td>\n",
       "      <td>中国科技出版传媒股份有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1981</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5980</th>\n",
       "      <td>5980</td>\n",
       "      <td>陈美枝</td>\n",
       "      <td>1980-03</td>\n",
       "      <td>北京白领服饰公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1980</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5981</th>\n",
       "      <td>5981</td>\n",
       "      <td>武朋兰</td>\n",
       "      <td>1978-10</td>\n",
       "      <td>北京万国融科信息科技有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1978</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5982</th>\n",
       "      <td>5982</td>\n",
       "      <td>黄建宁</td>\n",
       "      <td>1980-02</td>\n",
       "      <td>北京交大思源科技有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1980</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5983</th>\n",
       "      <td>5983</td>\n",
       "      <td>唐晓琴</td>\n",
       "      <td>1981-08</td>\n",
       "      <td>优客工场（北京）创业投资有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1981</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5984</th>\n",
       "      <td>5984</td>\n",
       "      <td>张锐</td>\n",
       "      <td>1975-07</td>\n",
       "      <td>北京紫通科技有限责任公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1975</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5985</th>\n",
       "      <td>5985</td>\n",
       "      <td>贾向雨</td>\n",
       "      <td>1976-03</td>\n",
       "      <td>丰电科技集团股份有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1976</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5986</th>\n",
       "      <td>5986</td>\n",
       "      <td>王勇</td>\n",
       "      <td>1979-09</td>\n",
       "      <td>同方股份有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1979</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5987</th>\n",
       "      <td>5987</td>\n",
       "      <td>王珣</td>\n",
       "      <td>1974-02</td>\n",
       "      <td>霍尼韦尔（中国）有限公司北京分公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1974</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5988</th>\n",
       "      <td>5988</td>\n",
       "      <td>裴加楠</td>\n",
       "      <td>1979-11</td>\n",
       "      <td>北京易普优能科技有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1979</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5989</th>\n",
       "      <td>5989</td>\n",
       "      <td>姜树道</td>\n",
       "      <td>1965-09</td>\n",
       "      <td>中冶赛迪电气技术有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1965</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5990</th>\n",
       "      <td>5990</td>\n",
       "      <td>郑建光</td>\n",
       "      <td>1979-01</td>\n",
       "      <td>北京博特数通技术有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1979</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5991</th>\n",
       "      <td>5991</td>\n",
       "      <td>林乐飞</td>\n",
       "      <td>1980-10</td>\n",
       "      <td>北京坦路来专利代理有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1980</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5992</th>\n",
       "      <td>5992</td>\n",
       "      <td>赵铁成</td>\n",
       "      <td>1978-01</td>\n",
       "      <td>东北证券股份有限公司北京分公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1978</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5993</th>\n",
       "      <td>5993</td>\n",
       "      <td>张金颖</td>\n",
       "      <td>1980-11</td>\n",
       "      <td>北京康佳源钢结构有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1980</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5994</th>\n",
       "      <td>5994</td>\n",
       "      <td>刘妍</td>\n",
       "      <td>1979-10</td>\n",
       "      <td>中国国际技术智力合作有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1979</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5995</th>\n",
       "      <td>5995</td>\n",
       "      <td>李泗良</td>\n",
       "      <td>1977-01</td>\n",
       "      <td>大唐软件技术股份有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1977</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5996</th>\n",
       "      <td>5996</td>\n",
       "      <td>杨向斌</td>\n",
       "      <td>1978-04</td>\n",
       "      <td>北京汇智开心教育科技有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1978</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5997</th>\n",
       "      <td>5997</td>\n",
       "      <td>孟庆春</td>\n",
       "      <td>1979-10</td>\n",
       "      <td>同方环境股份有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1979</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5998</th>\n",
       "      <td>5998</td>\n",
       "      <td>许鹏</td>\n",
       "      <td>1981-09</td>\n",
       "      <td>北京沃东天骏信息技术有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1981</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5999</th>\n",
       "      <td>5999</td>\n",
       "      <td>刘斌</td>\n",
       "      <td>1980-07</td>\n",
       "      <td>北京沃东天骏信息技术有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1980</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6000</th>\n",
       "      <td>6000</td>\n",
       "      <td>耿秀波</td>\n",
       "      <td>1984-03</td>\n",
       "      <td>微软（中国）有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6001</th>\n",
       "      <td>6001</td>\n",
       "      <td>李嘉</td>\n",
       "      <td>1979-06</td>\n",
       "      <td>英思特（北京）建筑设计咨询有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1979</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6002</th>\n",
       "      <td>6002</td>\n",
       "      <td>安新杰</td>\n",
       "      <td>1978-05</td>\n",
       "      <td>阿里巴巴（北京）软件服务有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1978</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6003</th>\n",
       "      <td>6003</td>\n",
       "      <td>刘照卿</td>\n",
       "      <td>1984-03</td>\n",
       "      <td>百度时代网络技术（北京）有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6004</th>\n",
       "      <td>6004</td>\n",
       "      <td>代宏</td>\n",
       "      <td>1978-09</td>\n",
       "      <td>信达证券股份有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1978</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6005</th>\n",
       "      <td>6005</td>\n",
       "      <td>姚致远</td>\n",
       "      <td>1982-04</td>\n",
       "      <td>慧与（中国）有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1982</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6006</th>\n",
       "      <td>6006</td>\n",
       "      <td>夏饮冰</td>\n",
       "      <td>1969-12</td>\n",
       "      <td>路博润管理(上海)有限公司北京分公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1969</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6007</th>\n",
       "      <td>6007</td>\n",
       "      <td>李华月</td>\n",
       "      <td>1979-06</td>\n",
       "      <td>北京金信知识产权代理有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1979</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6007 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        序号   姓名     出生年月                   单位名称    积分分值  year  age\n",
       "序号                                                                \n",
       "1        1   朱虹  1978-11                  中央电视台  125.79  1978   41\n",
       "2        2   胡瑾  1977-12           北京安御道合科技有限公司  124.49  1977   42\n",
       "3        3  熊海平  1972-10        北京融信通金服科技股份有限公司  120.33  1972   47\n",
       "4        4   程刚  1975-01       北京清水爱派建筑设计股份有限公司  120.00  1975   44\n",
       "5        5  陈秀娟  1974-05               国网物资有限公司  119.13  1974   45\n",
       "6        6  贺玉刚  1978-02           北京金蝶管理软件有限公司  119.09  1978   41\n",
       "7        7   郭琳  1972-08    毕马威华振会计师事务所（特殊普通合伙）  119.00  1972   47\n",
       "8        8   张静  1974-01           北京市北斗鼎铭律师事务所  117.96  1974   45\n",
       "9        9   徐轶  1975-08          新世纪检验认证股份有限公司  117.20  1975   44\n",
       "10      10  董国群  1972-03           北京中建地产有限责任公司  116.99  1972   47\n",
       "11      11   段昌  1976-06          华为技术有限公司北京研究所  116.67  1976   43\n",
       "12      12   郭斌  1972-12           北京华泰科信科技有限公司  116.67  1972   47\n",
       "13      13  孔樊涌  1976-10       北京中油瑞飞信息技术有限责任公司  116.63  1976   43\n",
       "14      14  罗怀梅  1976-06           北京计鹏信息咨询有限公司  116.17  1976   43\n",
       "15      15  朱莉莉  1978-10       百度在线网络技术（北京）有限公司  116.00  1978   41\n",
       "16      16  王中宇  1972-11         钉钉互联（北京）技术有限公司  115.96  1972   47\n",
       "17      17  谢用辉  1974-09           北京新脉远望科技有限公司  115.67  1974   45\n",
       "18      18  国维石  1976-03           中铁天丰建筑工程有限公司  115.63  1976   43\n",
       "19      19  刘龙龙  1975-04                  中央电视台  115.04  1975   44\n",
       "20      20  李启武  1973-04  华泰证券股份有限公司北京月坛南街证券营业部  114.96  1973   46\n",
       "21      21  梁宏旭  1976-02       北京城建北方设备安装有限责任公司  114.95  1976   43\n",
       "22      22  张冬梅  1972-11        北京亿速码数据处理有限责任公司  114.79  1972   47\n",
       "23      23  刘东风  1977-05          中节能清洁技术发展有限公司  114.66  1977   42\n",
       "24      24  高小良  1972-12        北京中青旅海天数码科技有限公司  114.08  1972   47\n",
       "25      25  郝建武  1976-07          华为技术有限公司北京研究所  113.96  1976   43\n",
       "26      26  杨瑞增  1972-03           中建二局装饰工程有限公司  113.79  1972   47\n",
       "27      27  何庆宁  1975-03       北京神州数码云科信息技术有限公司  113.71  1975   44\n",
       "28      28   刘洋  1970-11       北京温都水城旅游饭店管理有限公司  113.46  1970   49\n",
       "29      29   杨宽  1976-08       北京博睿智业人力资源顾问有限公司  113.41  1976   43\n",
       "30      30   许畅  1973-08        西安杨森制药有限公司北京分公司  113.30  1973   46\n",
       "...    ...  ...      ...                    ...     ...   ...  ...\n",
       "5978  5978  张晓燕  1977-07         北京三重华星电子科技有限公司   93.58  1977   42\n",
       "5979  5979   甘莉  1981-11         中国科技出版传媒股份有限公司   93.58  1981   38\n",
       "5980  5980  陈美枝  1980-03               北京白领服饰公司   93.58  1980   39\n",
       "5981  5981  武朋兰  1978-10         北京万国融科信息科技有限公司   93.58  1978   41\n",
       "5982  5982  黄建宁  1980-02           北京交大思源科技有限公司   93.58  1980   39\n",
       "5983  5983  唐晓琴  1981-08       优客工场（北京）创业投资有限公司   93.58  1981   38\n",
       "5984  5984   张锐  1975-07           北京紫通科技有限责任公司   93.58  1975   44\n",
       "5985  5985  贾向雨  1976-03           丰电科技集团股份有限公司   93.58  1976   43\n",
       "5986  5986   王勇  1979-09               同方股份有限公司   93.58  1979   40\n",
       "5987  5987   王珣  1974-02      霍尼韦尔（中国）有限公司北京分公司   93.58  1974   45\n",
       "5988  5988  裴加楠  1979-11           北京易普优能科技有限公司   93.58  1979   40\n",
       "5989  5989  姜树道  1965-09           中冶赛迪电气技术有限公司   93.58  1965   54\n",
       "5990  5990  郑建光  1979-01           北京博特数通技术有限公司   93.58  1979   40\n",
       "5991  5991  林乐飞  1980-10          北京坦路来专利代理有限公司   93.58  1980   39\n",
       "5992  5992  赵铁成  1978-01        东北证券股份有限公司北京分公司   93.58  1978   41\n",
       "5993  5993  张金颖  1980-11           北京康佳源钢结构有限公司   93.58  1980   39\n",
       "5994  5994   刘妍  1979-10         中国国际技术智力合作有限公司   93.58  1979   40\n",
       "5995  5995  李泗良  1977-01           大唐软件技术股份有限公司   93.58  1977   42\n",
       "5996  5996  杨向斌  1978-04         北京汇智开心教育科技有限公司   93.58  1978   41\n",
       "5997  5997  孟庆春  1979-10             同方环境股份有限公司   93.58  1979   40\n",
       "5998  5998   许鹏  1981-09         北京沃东天骏信息技术有限公司   93.58  1981   38\n",
       "5999  5999   刘斌  1980-07         北京沃东天骏信息技术有限公司   93.58  1980   39\n",
       "6000  6000  耿秀波  1984-03             微软（中国）有限公司   93.58  1984   35\n",
       "6001  6001   李嘉  1979-06      英思特（北京）建筑设计咨询有限公司   93.58  1979   40\n",
       "6002  6002  安新杰  1978-05       阿里巴巴（北京）软件服务有限公司   93.58  1978   41\n",
       "6003  6003  刘照卿  1984-03       百度时代网络技术（北京）有限公司   93.58  1984   35\n",
       "6004  6004   代宏  1978-09             信达证券股份有限公司   93.58  1978   41\n",
       "6005  6005  姚致远  1982-04             慧与（中国）有限公司   93.58  1982   37\n",
       "6006  6006  夏饮冰  1969-12     路博润管理(上海)有限公司北京分公司   93.58  1969   50\n",
       "6007  6007  李华月  1979-06         北京金信知识产权代理有限公司   93.58  1979   40\n",
       "\n",
       "[6007 rows x 7 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "year\n",
       "1959      1\n",
       "1960      1\n",
       "1961      1\n",
       "1962      2\n",
       "1963      2\n",
       "1964      6\n",
       "1965      9\n",
       "1966      5\n",
       "1967      3\n",
       "1968      8\n",
       "1969      8\n",
       "1970     12\n",
       "1971      3\n",
       "1972    274\n",
       "1973    393\n",
       "1974    516\n",
       "1975    631\n",
       "1976    735\n",
       "1977    743\n",
       "1978    791\n",
       "1979    660\n",
       "1980    476\n",
       "1981    361\n",
       "1982    235\n",
       "1983     93\n",
       "1984     29\n",
       "1985      7\n",
       "1986      1\n",
       "1987      1\n",
       "dtype: int64"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAELCAYAAADX3k30AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAGYJJREFUeJzt3X+QXfV53/H3B2RAsI4kwFkzkhzRQbbTIozRRlbrJN1FifmVROrESnFUIxElm0yxi2OlkZxmxuNO25EnAWImLpON5UZkbNaUmpGiYGIqe5M6iTASBiSQbQmM5ZVkAUYSWRCJ5Tz9434XLld39577a+/e735eMzt7zvc8e87z6Ow+9+jcc+5RRGBmZvk6q9MJmJlZe7nRm5llzo3ezCxzbvRmZplzozczy5wbvZlZ5tzozcwy50ZvZpY5N3ozs8zN6nQCABdffHEsWrRoyrf78ssvc8EFF0z5dtvJNXWH3GrKrR7ojpr27NnzQkS8pVbctGj0ixYtYvfu3VO+3ZGREfr7+6d8u+3kmrpDbjXlVg90R02SvlskzqduzMwy50ZvZpY5N3ozs8wVavSSflvSk5L2SbpH0nmSLpX0sKQDkr4g6ZwUe26aP5iWL2pnAWZmNrmajV7SfOA/AX0RcTlwNnAj8EngjohYDBwH1qcfWQ8cj4jLgDtSnJmZdUjRUzezgNmSZgHnA0eBq4H70vKtwKo0vTLNk5avkKTWpGtmZvVSkSdMSboV+O/AKeDLwK3ArnTUjqSFwJci4nJJ+4BrI2I0LXsaeE9EvFCxzkFgEKC3t3fp8PBw66oqaGxsjJ6eninfbju5pu6QW0251QPdUdPAwMCeiOirFVfzOnpJ8ygdpV8KnAD+N3BdldDxV4xqR+9nvJpExBAwBNDX1xeduF61G66TrZdr6g651ZRbPZBXTUVumPo54DsR8TyApC8C/waYK2lWRJwGFgBHUvwosBAYTad65gAvtjxzMytk0aa/rBnz7OYbpiAT65Qi5+gPAcslnZ/Ota8AngK+Crw/xawFtqXp7WmetPwr4SeQm5l1TM1GHxEPU3pT9VFgb/qZIWAj8FFJB4GLgC3pR7YAF6XxjwKb2pC3mZkVVOizbiLi48DHK4afAZZViX0VWN18amZm1gq+M9bMLHNu9GZmmXOjNzPLnBu9mVnm3OjNzDLnRm9mljk3ejOzzLnRm5llzo3ezCxzhe6MNbPpp9aHlfmDymycj+jNzDLnI3qzacRH6dYOPqI3M8ucG72ZWebc6M3MMudGb2aWOTd6M7PM1Wz0kt4h6bGyr5ckfUTShZIeknQgfZ+X4iXpTkkHJT0h6ar2l2FmZhMp8szYb0XElRFxJbAUeAW4n9KzYHdGxGJgJ68/G/Y6YHH6GgTuakfiZmZWTL2nblYAT0fEd4GVwNY0vhVYlaZXAndHyS5grqRLWpKtmZnVTRFRPFj6LPBoRPyxpBMRMbds2fGImCdpB7A5Ir6WxncCGyNid8W6Bikd8dPb27t0eHi4BeXUZ2xsjJ6eninfbju5pu4wUU17D5+c9OeWzJ9Td2ytuMr1NmIm7aPpZGBgYE9E9NWKK3xnrKRzgF8CPlYrtMrYGa8mETEEDAH09fVFf39/0VRaZmRkhE5st51cU3eYqKZ1te6MXfP6zxSNrRVXud5GzKR91I3qOXVzHaWj+WNp/tj4KZn0/bk0PgosLPu5BcCRZhM1M7PG1NPoPwDcUza/HVibptcC28rGb0pX3ywHTkbE0aYzNTOzhhQ6dSPpfODngd8sG94M3CtpPXAIWJ3GHwCuBw5SukLn5pZla2ZmdSvU6CPiFeCiirEfULoKpzI2gFtakp2ZmTXNd8aamWXOjd7MLHNu9GZmmXOjNzPLnBu9mVnm/MxYM3uNn1mbJx/Rm5llzo3ezCxzbvRmZplzozczy5wbvZlZ5tzozcwy58srzdqs2iWLG5acfsMDQXzZorWTj+jNzDLnRm9mljk3ejOzzLnRm5llrlCjlzRX0n2Svilpv6R/LelCSQ9JOpC+z0uxknSnpIOSnpB0VXtLMDOzyRQ9ov8U8GBEvBN4F7Af2ATsjIjFwM40D3AdsDh9DQJ3tTRjMzOrS81GL+nHgJ8FtgBExD9FxAlgJbA1hW0FVqXplcDdUbILmCvpkpZnbmZmhaj0LO9JAqQrgSHgKUpH83uAW4HDETG3LO54RMyTtAPYHBFfS+M7gY0RsbtivYOUjvjp7e1dOjw83LqqChobG6Onp2fKt9tOrmn62Xv45BljvbPh2KnX55fMnzNhbLnxuHpia8U1uv1y3b6PqumGmgYGBvZERF+tuCI3TM0CrgI+HBEPS/oUr5+mqUZVxs54NYmIIUovIPT19UV/f3+BVFprZGSETmy3nVzT9LNughumbtv7+p/fs2v6J4wtNx5XT2ytuEa3X67b91E1OdVU5Bz9KDAaEQ+n+fsoNf5j46dk0vfnyuIXlv38AuBIa9I1M7N61Wz0EfF94HuS3pGGVlA6jbMdWJvG1gLb0vR24KZ09c1y4GREHG1t2mZmVlTRz7r5MPA5SecAzwA3U3qRuFfSeuAQsDrFPgBcDxwEXkmxZmbWIYUafUQ8BlQ74b+iSmwAtzSZl5mZtYjvjDUzy5wbvZlZ5tzozcwy50ZvZpY5N3ozs8y50ZuZZc6N3swsc270ZmaZc6M3M8ucG72ZWebc6M3MMudGb2aWOTd6M7PMudGbmWXOjd7MLHNu9GZmmSv6hCkzq7Co1oO0N98wRZmYTa7QEb2kZyXtlfSYpN1p7EJJD0k6kL7PS+OSdKekg5KekHRVOwswM7PJ1XPqZiAiroyI8UcKbgJ2RsRiYGeaB7gOWJy+BoG7WpWsmZnVr5lz9CuBrWl6K7CqbPzuKNkFzJV0SRPbMTOzJqj0LO8aQdJ3gONAAH8SEUOSTkTE3LKY4xExT9IOYHNEfC2N7wQ2RsTuinUOUjrip7e3d+nw8HDLiipqbGyMnp6eKd9uO7mmqbP38MlJly+ZP2fCuN7ZcOxUsdhq62x2+43Glm+/3HTdR83ohpoGBgb2lJ1lmVDRN2PfGxFHJP048JCkb04SqypjZ7yaRMQQMATQ19cX/f39BVNpnZGRETqx3XZyTVNnXa03Y9f0Txi3Yclpbts7q1BstXU2u/1GY8u3X2667qNm5FRToVM3EXEkfX8OuB9YBhwbPyWTvj+XwkeBhWU/vgA40qqEzcysPjUbvaQLJL15fBp4H7AP2A6sTWFrgW1pejtwU7r6ZjlwMiKOtjxzMzMrpMipm17gfknj8Z+PiAclPQLcK2k9cAhYneIfAK4HDgKvADe3PGszMyusZqOPiGeAd1UZ/wGwosp4ALe0JDszM2uaPwLBzCxz/ggEM6tb5cc/bFhy+owrdvwRENOHj+jNzDLnRm9mljk3ejOzzLnRm5llzo3ezCxzbvRmZplzozczy5wbvZlZ5tzozcwy50ZvZpY5N3ozs8y50ZuZZc6N3swsc270ZmaZc6M3M8tc4UYv6WxJ35C0I81fKulhSQckfUHSOWn83DR/MC1f1J7UzcysiHqO6G8F9pfNfxK4IyIWA8eB9Wl8PXA8Ii4D7khxZmbWIYUavaQFwA3AZ9K8gKuB+1LIVmBVml6Z5knLV6R4MzPrgKJH9H8E/C7wz2n+IuBERJxO86PA/DQ9H/geQFp+MsWbmVkHKCImD5B+Abg+Iv6jpH7gd4Cbgb9Pp2eQtBB4ICKWSHoSuCYiRtOyp4FlEfGDivUOAoMAvb29S4eHh1tbWQFjY2P09PRM+XbbyTVNnb2HT066fMn8ORPG9c6GY6eKxVZbZ7PbbzR2orjKeipz7UbT9feu3MDAwJ6I6KsVV+Th4O8FfknS9cB5wI9ROsKfK2lWOmpfABxJ8aPAQmBU0ixgDvBi5UojYggYAujr64v+/v4CqbTWyMgIndhuO7mm5lQ+9Lqa8YdeVz4M+4y4Nf0Txm1Ycprb9s4qFFttnc1uv9HYieIq66nMtRvl9LdU89RNRHwsIhZExCLgRuArEbEG+Crw/hS2FtiWprenedLyr0St/zaYmVnbNHMd/Ubgo5IOUjoHvyWNbwEuSuMfBTY1l6KZmTWjyKmb10TECDCSpp8BllWJeRVY3YLczMysBXxnrJlZ5tzozcwy50ZvZpY5N3ozs8y50ZuZZa6uq27MzOpV6ya08RvQrH18RG9mljk3ejOzzLnRm5llzo3ezCxzbvRmZplzozczy5wbvZlZ5tzozcwy50ZvZpY5N3ozs8y50ZuZZc6N3swsczUbvaTzJH1d0uOSnpT0iTR+qaSHJR2Q9AVJ56Txc9P8wbR8UXtLMDOzyRQ5ov9H4OqIeBdwJXCtpOXAJ4E7ImIxcBxYn+LXA8cj4jLgjhRnZmYdUrPRR8lYmn1T+grgauC+NL4VWJWmV6Z50vIVktSyjM3MrC6KiNpB0tnAHuAy4NPAHwC70lE7khYCX4qIyyXtA66NiNG07GngPRHxQsU6B4FBgN7e3qXDw8Otq6qgsbExenp6pny77eSamrP38MmaMUvmzykUO1lc72w4dqrxdTa7/UZjJ4qrrKeRdU433fC3NDAwsCci+mrFFXrwSET8CLhS0lzgfuAnq4Wl79WO3s94NYmIIWAIoK+vL/r7+4uk0lIjIyN0Yrvt5Jqas67GQzIAnl3TXyh2srgNS05z295ZhWKrrbPZ7TcaO1FcZT2NrHO6yelvqa6rbiLiBDACLAfmShrfswuAI2l6FFgIkJbPAV5sRbJmZla/IlfdvCUdySNpNvBzwH7gq8D7U9haYFua3p7mScu/EkXOD5mZWVsUOXVzCbA1nac/C7g3InZIegoYlvTfgG8AW1L8FuDPJR2kdCR/YxvyNjOzgmo2+oh4Anh3lfFngGVVxl8FVrckOzMza5rvjDUzy1yhq27Mut2iWld+bL5hijIxm3o+ojczy5wbvZlZ5tzozcwy50ZvZpY5N3ozs8y50ZuZZc6N3swsc270ZmaZc6M3M8uc74w1s2mh1t3L4DuYG+UjejOzzLnRm5llzo3ezCxzbvRmZplzozczy1yRZ8YulPRVSfslPSnp1jR+oaSHJB1I3+elcUm6U9JBSU9IuqrdRZiZ2cSKHNGfBjZExE8Cy4FbJP1LYBOwMyIWAzvTPMB1wOL0NQjc1fKszcyssJqNPiKORsSjafofgP3AfGAlsDWFbQVWpemVwN1RsguYK+mSlmduZmaFKCKKB0uLgL8BLgcORcTcsmXHI2KepB3A5oj4WhrfCWyMiN0V6xqkdMRPb2/v0uHh4SZLqd/Y2Bg9PT1Tvt12ck3V7T18ctLlS+bPKRRXT+xkcb2z4dipxtfZ7PYbjZ0orrKeVqxzstip0A1/SwMDA3sioq9WXOE7YyX1AP8H+EhEvCRpwtAqY2e8mkTEEDAE0NfXF/39/UVTaZmRkRE6sd12ck3Vrav1zNg1/YXi6omdLG7DktPctndWodhq62x2+43GThRXWU8r1jlZ7FTI6W+p0FU3kt5Eqcl/LiK+mIaPjZ+SSd+fS+OjwMKyH18AHGlNumZmVq8iV90I2ALsj4jbyxZtB9am6bXAtrLxm9LVN8uBkxFxtIU5m5lZHYqcunkv8EFgr6TH0tjvAZuBeyWtBw4Bq9OyB4DrgYPAK8DNLc3YzMzqUrPRpzdVJzohv6JKfAC3NJmXmZm1iO+MNTPLnBu9mVnm3OjNzDLnRm9mljk3ejOzzLnRm5llzo3ezCxzbvRmZplzozczy5wbvZlZ5tzozcwy50ZvZpY5N3ozs8y50ZuZZc6N3swsc270ZmaZc6M3M8tckWfGflbSc5L2lY1dKOkhSQfS93lpXJLulHRQ0hOSrmpn8mZmVluRI/o/A66tGNsE7IyIxcDONA9wHbA4fQ0Cd7UmTTMza1TNRh8RfwO8WDG8EtiaprcCq8rG746SXcBcSZe0KlkzM6ufSs/yrhEkLQJ2RMTlaf5ERMwtW348IuZJ2gFsTg8UR9JOYGNE7K6yzkFKR/309vYuHR4ebkE59RkbG6Onp2fKt9tOrqm6vYdPTrp8yfw5heLqiZ0srnc2HDvV+Dqb3X6jsRPFVdbTinVOFjsVuuFvaWBgYE9E9NWKm9Xi7arKWNVXkogYAoYA+vr6or+/v8Wp1DYyMkIntttOrqm6dZv+ctLlz67pLxRXT+xkcRuWnOa2vbMKxVZbZ7PbbzR2orjKelqxzslip0JOf0uNNvpjki6JiKPp1MxzaXwUWFgWtwA40kyCZmaVFtV68dh8wxRl0h0avbxyO7A2Ta8FtpWN35SuvlkOnIyIo03maGZmTah5RC/pHqAfuFjSKPBxYDNwr6T1wCFgdQp/ALgeOAi8AtzchpzNzKwONRt9RHxggkUrqsQGcEuzSZmZWev4zlgzs8y50ZuZZc6N3swsc270ZmaZc6M3M8ucG72ZWebc6M3MMudGb2aWOTd6M7PMudGbmWXOjd7MLHNu9GZmmXOjNzPLXKufMGVmNm3UekAJzIyHlPiI3swsc270ZmaZc6M3M8tcW87RS7oW+BRwNvCZiNjcju1YnirPq25Ycpp1ZWMz4ZyqWSu1vNFLOhv4NPDzwCjwiKTtEfFUq7dlnW2K9bzRVSvWzds6rdbfEnTv72k7juiXAQcj4hkAScPASsCNvqB2XCngqw/MZi6VnufdwhVK7weujYhfT/MfBN4TER+qiBsEBtPsO4BvtTSRYi4GXujAdtvJNXWH3GrKrR7ojpp+IiLeUiuoHUf0qjJ2xqtJRAwBQ23YfmGSdkdEXydzaDXX1B1yqym3eiCvmtpx1c0osLBsfgFwpA3bMTOzAtrR6B8BFku6VNI5wI3A9jZsx8zMCmj5qZuIOC3pQ8BfUbq88rMR8WSrt9MiHT111CauqTvkVlNu9UBGNbX8zVgzM5tefGesmVnm3OjNzDLnRm9mljk3ejOzzLnRm5llzk+YMrOGSHonpc+xmk/p7vcjwPaI2N/RxOwMM+rySknXAKt44y/mtoh4sKOJNUjSxRHxQtn8f6D0oXL7gD+NLt253k/Tn6SNwAeAYUp3w0PpLvgbgeFu/2hyST9N2kcR8eVO59OsGdPoJf0R8Hbgbt74i3kTcCAibu1Ubo2S9GhEXJWmfx/4GeDzwC8AoxHx253MrxHeT91B0reBfxURP6wYPwd4MiIWdyazxkj6ekQsS9O/AdwC3A+8D/iLrn/hmkGN/tsR8fYq4wK+3W2/mACSvhER707TjwI/ExEvS3oT8GhELOlshvXzfuoOkr4JXBMR360Y/wngyxHxjs5k1piKffQIcH1EPC/pAmBXN+6jcjPpHP2rkpZFxNcrxn8KeLUTCbXAbEnvpvSm+tkR8TJARPxQ0o86m1rDvJ+6w0eAnZIOAN9LY28DLgM+NOFPTV9nSZpHaR8pIp4HSC/IpzubWvNmUqNfB9wl6c28fkpgIfBSWtaNjgK3p+kXJV0SEUclXQR06y/nzcD/zGw/fZ/M9lNEPCjp7ZTOY8+n9PHko8AjEdGNL15zgD2U6ghJb42I70vqofpHr3eVGXPqZpykt1L2ixkR3+9wSi0n6SzgvIh4pdO5NGqG7KezgXO7dT9JehvwUkSckLQI6AP2T+MPMaybpPOB3oj4TqdzacaMafTpTaIfjl/hIGkAuIrSG0fdejXHRDU9FRFf6mhyDZJ0RUQ80ek8WinTmjYBvwn8I/CHwO8AfwssB7ZExO2T/Pi0NMEL1zcjYl9HE2uBmdToHwf6I+K4pP8M/DvgAeDfArsj4mMdTbABNWraExGbOppgA9I56+8A9wD35PBQ+UxrepJSIzwfeBb4F2VvXj4cEZd3Mr965fjCVW4mNfp94798knZTuvLhlKRZlK58uKKzGdYv05q+AXyQ0jXa/x54mVKDHI6IZzuYWsMyremJiLginX46Crw1Iv45LdvXhY0+qxeuSjPpIxBekjS+s14AzkvTs+jef4cca4qI2BcR/yUiLgN+A/hx4P9J+rsO59aoHGt6VNLngS8CO4GtktZI2gJ04/9YfhQRp4ATwCngB1C66qajWbXITDqivwL4c+DxNPRe4K+BK4DbI+LzncqtUZnW9Nr1zBXjAn42Iv66A2k1JdOaZgGrKd25fB/wHkr/YzkEfLrbGqSkPwPOAS4AXqF0NdSDwNXAmyPiVzqXXfNmTKOH165yeB+lOy9nUboc7K8i4kRHE2tCbjVJ+tVufIGaTI415Sa3F65KM6rRm1lrpOvLfxf4ZUofUfFPwNPAXRGxtZO52Zm69Txu3ST1SPqvkp6UdFLS85J2SVrX6dwa5Zq6Q441AZ8DngGuAT4B3EnpDeerJf2PTibWiEn20dpO59YKM+aIXtI2Sh9S9H+BX6F0Lm4Y+H3gcET8XgfTa4hr6g6Z1vR4RLyrbP6RiPipdLPeUxHxzg6mV7cc99EbRMSM+AIer5h/JH0/i9JNER3P0TW5pm75Av4O+Ok0/YuU3hcaX/atTufnffTGrxlz6gZ4WaXPmEbSLwIvAkTp2t9u/SwL19Qdcqzpt4DbJZ0ANgIfBpD0FuDTnUysQTnuo9fMpA81+y3gM+mDmPYBvwZd/YsJrqlbZFdTlD7SYVmV8ecl/UMHUmpWdvuo3Ixp9Bn+YrqmLpFjTTV8AvhfnU6iHrnvoxnzZuxkJB2KiLd1Oo9Wck3doVtrkjTRh7QJeHtEnDuV+bRTt+6jcjPmiL7GL2bvVObSKq6pO+RYE6W8rwGOV4yL0hu1XSXTffSaGdPoyewXM3FN3SHHmnYAPRHxWOUCSSNTn07TctxHr5lJjT63X0xwTd0iu5oiYv0ky351KnNpkez2UTmfozczy9xMuo7ezGxGcqM3M8ucG72ZWebc6M3MMvf/AT29mBCCWorAAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "data = df.groupby('year').size()\n",
    "plt.bar(data.index, data)\n",
    "plt.grid(True)\n",
    "plt.xticks(rotation=90)\n",
    "display(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1239abd68>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYAAAAD8CAYAAAB+UHOxAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAFAxJREFUeJzt3X+QXWV9x/H3t0QQzUj4oVsmiQ3W1IqktriDqFNnY1r5oTXYyojDSFA6mc6g1ZqOhDpTnLZOsZb6o2NxUqFGhxIpaslIFNPolfpHUOIPAiLNihQW0qCCsSuoXf32j/ukc13uZrP37t6zt8/7NbNzz3nOc8/57mHJZ5/nnLM3MhNJUn1+qekCJEnNMAAkqVIGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJlVrSdAGHc9JJJ+WqVasGeswf/ehHPPWpTx3oMefLMNcOw12/tTdjmGuHhat/z54938vMp8/Wb1EHwKpVq7j99tsHesxWq8XY2NhAjzlfhrl2GO76rb0Zw1w7LFz9EfGfR9LPKSBJqpQBIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASarUon4SuF+rNt8847b7rnzFACuRpMXHEYAkVcoAkKRKGQCSVCkDQJIqZQBIUqUMAEmqlAEgSZUyACSpUgaAJFXKAJCkShkAklQpA0CSKmUASFKlZg2AiLg2Ih6OiDs72t4TEd+KiDsi4lMRsaxj2+URMR4R90TEWR3tZ5e28YjYPP/fiiRpLo5kBPAR4OxpbTuB0zLzN4D/AC4HiIhTgQuA55X3/ENEHBURRwEfBM4BTgVeV/pKkhoyawBk5q3AI9PaPpeZU2V1N7CiLK8HtmXmTzLzO8A4cEb5Gs/MezPzp8C20leS1JD5+ECYNwIfL8vLaQfCIROlDeCBae0v7LaziNgIbAQYGRmh1Wr1XNimNVMzbptpv5OTk30ds0nDXDsMd/3W3oxhrh2ar7+vAIiIdwBTwHWHmrp0S7qPNLLbPjNzC7AFYHR0NMfGxnqu7+LDfSLYhd3322q16OeYTRrm2mG467f2Zgxz7dB8/T0HQERsAF4JrMvMQ/+YTwArO7qtAB4qyzO1S5Ia0NNtoBFxNnAZ8KrMfKxj03bggog4JiJOAVYDXwa+AqyOiFMi4mjaF4q391e6JKkfs44AIuJ6YAw4KSImgCto3/VzDLAzIgB2Z+YfZeZdEXED8E3aU0OXZubPyn7eBNwCHAVcm5l3LcD3I0k6QrMGQGa+rkvzNYfp/y7gXV3adwA75lSdJGnB+CSwJFXKAJCkShkAklQpA0CSKmUASFKlDABJqpQBIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVCkDQJIqZQBIUqUMAEmq1KwBEBHXRsTDEXFnR9sJEbEzIvaV1+NLe0TEByJiPCLuiIjTO96zofTfFxEbFubbkSQdqSMZAXwEOHta22ZgV2auBnaVdYBzgNXlayNwNbQDA7gCeCFwBnDFodCQJDVj1gDIzFuBR6Y1rwe2luWtwHkd7R/Ntt3Asog4GTgL2JmZj2Tmo8BOnhgqkqQB6vUawEhm7gcor88o7cuBBzr6TZS2mdolSQ1ZMs/7iy5teZj2J+4gYiPt6SNGRkZotVo9F7NpzdSM22ba7+TkZF/HbNIw1w7DXb+1N2OYa4fm6+81AA5ExMmZub9M8Txc2ieAlR39VgAPlfaxae2tbjvOzC3AFoDR0dEcGxvr1u2IXLz55hm33Xdh9/22Wi36OWaThrl2GO76rb0Zw1w7NF9/r1NA24FDd/JsAG7qaL+o3A10JnCwTBHdArw8Io4vF39fXtokSQ2ZdQQQEdfT/u39pIiYoH03z5XADRFxCXA/cH7pvgM4FxgHHgPeAJCZj0TEXwJfKf3+IjOnX1iWJA3QrAGQma+bYdO6Ln0TuHSG/VwLXDun6iRJC8YngSWpUgaAJFXKAJCkShkAklQpA0CSKmUASFKlDABJqpQBIEmVmu8/Bjc0Vs3wd4I2rZni4s03c9+VrxhwRZI0WI4AJKlSBoAkVcoAkKRKGQCSVCkDQJIqZQBIUqUMAEmqlAEgSZUyACSpUgaAJFXKAJCkShkAklQpA0CSKmUASFKl+gqAiPiTiLgrIu6MiOsj4skRcUpE3BYR+yLi4xFxdOl7TFkfL9tXzcc3IEnqTc8BEBHLgT8GRjPzNOAo4ALg3cB7M3M18ChwSXnLJcCjmfls4L2lnySpIf1OAS0Bjo2IJcBTgP3Ay4Aby/atwHlleX1Zp2xfFxHR5/ElST3qOQAy80Hgb4H7af/DfxDYA/wgM6dKtwlgeVleDjxQ3jtV+p/Y6/ElSf2JzOztjRHHA58AXgv8APiXsn5FmeYhIlYCOzJzTUTcBZyVmRNl27eBMzLz+9P2uxHYCDAyMvKCbdu29VQfwN4HD875PSPHwoHHYc3y43o+blMmJydZunRp02X0bJjrt/ZmDHPtsHD1r127dk9mjs7Wr5/PBP4d4DuZ+V2AiPgk8GJgWUQsKb/lrwAeKv0ngJXARJkyOg54ZPpOM3MLsAVgdHQ0x8bGei7w4hk+9/dwNq2Z4qq9S7jvwt6P25RWq0U/56tpw1y/tTdjmGuH5uvv5xrA/cCZEfGUMpe/Dvgm8AXgNaXPBuCmsry9rFO2fz57HX5IkvrWzzWA22hfzP0qsLfsawtwGfC2iBinPcd/TXnLNcCJpf1twOY+6pYk9amfKSAy8wrgimnN9wJndOn7Y+D8fo4nSZo/PgksSZUyACSpUgaAJFXKAJCkShkAklQpA0CSKmUASFKlDABJqpQBIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVCkDQJIq1VcARMSyiLgxIr4VEXdHxIsi4oSI2BkR+8rr8aVvRMQHImI8Iu6IiNPn51uQJPWi3xHA+4HPZuavA88H7gY2A7syczWwq6wDnAOsLl8bgav7PLYkqQ89B0BEPA14KXANQGb+NDN/AKwHtpZuW4HzyvJ64KPZthtYFhEn91y5JKkv/YwAngV8F/iniPhaRHw4Ip4KjGTmfoDy+ozSfznwQMf7J0qbJKkBkZm9vTFiFNgNvCQzb4uI9wM/BN6cmcs6+j2amcdHxM3AX2fml0r7LuDtmbln2n430p4iYmRk5AXbtm3rqT6AvQ8enPN7Ro6FA4/DmuXH9XzcpkxOTrJ06dKmy+jZMNdv7c0Y5tph4epfu3btnswcna3fkj6OMQFMZOZtZf1G2vP9ByLi5MzcX6Z4Hu7ov7Lj/SuAh6bvNDO3AFsARkdHc2xsrOcCL95885zfs2nNFFftXcJ9F/Z+3Ka0Wi36OV9NG+b6rb0Zw1w7NF9/z1NAmflfwAMR8ZzStA74JrAd2FDaNgA3leXtwEXlbqAzgYOHpookSYPXzwgA4M3AdRFxNHAv8AbaoXJDRFwC3A+cX/ruAM4FxoHHSl9JUkP6CoDM/DrQbZ5pXZe+CVzaz/EGadVhpo/uu/IVA6xEkhaGTwJLUqUMAEmqlAEgSZUyACSpUgaAJFWq39tAq3S4O4TAu4QkDQdHAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVCkDQJIqZQBIUqUMAEmqlAEgSZUyACSpUgaAJFXKAJCkShkAklSpvgMgIo6KiK9FxKfL+ikRcVtE7IuIj0fE0aX9mLI+Xrav6vfYkqTezcdHQr4FuBt4Wll/N/DezNwWER8CLgGuLq+PZuazI+KC0u+183D8RcePjJQ0DPoaAUTECuAVwIfLegAvA24sXbYC55Xl9WWdsn1d6S9JakC/U0DvA94O/Lysnwj8IDOnyvoEsLwsLwceACjbD5b+kqQG9DwFFBGvBB7OzD0RMXaouUvXPIJtnfvdCGwEGBkZodVq9Voim9ZMzd5pmpFje3vfXPTzPR3O5OTkgu17EIa5fmtvxjDXDs3X3881gJcAr4qIc4En074G8D5gWUQsKb/lrwAeKv0ngJXAREQsAY4DHpm+08zcAmwBGB0dzbGxsZ4LvHiWufhuNq2Z4qq983FpZGb3XTi2IPtttVr0c76aNsz1W3szhrl2aL7+nqeAMvPyzFyRmauAC4DPZ+aFwBeA15RuG4CbyvL2sk7Z/vnMfMIIQJI0GAvxq+5lwLaI+Cvga8A1pf0a4GMRMU77N/8LFuDYQ+Fwdwl5h5CkQZmXAMjMFtAqy/cCZ3Tp82Pg/Pk4niSpfz4JLEmVMgAkqVIGgCRVygCQpEot7A3vmjP/jpCkQXEEIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkirlbaBD5nC3iW5aM8XY4EqRNOQcAUhSpQwASaqUASBJlTIAJKlSBoAkVcq7gP6f8eMmJR0pRwCSVCkDQJIqZQBIUqUMAEmqlAEgSZXqOQAiYmVEfCEi7o6IuyLiLaX9hIjYGRH7yuvxpT0i4gMRMR4Rd0TE6fP1TUiS5q6fEcAUsCkznwucCVwaEacCm4Fdmbka2FXWAc4BVpevjcDVfRxbktSnngMgM/dn5lfL8n8DdwPLgfXA1tJtK3BeWV4PfDTbdgPLIuLkniuXJPUlMrP/nUSsAm4FTgPuz8xlHdsezczjI+LTwJWZ+aXSvgu4LDNvn7avjbRHCIyMjLxg27ZtPde198GDc37PyLFw4PGeD9mofmtfs/y4+SumB5OTkyxdurTRGnpl7c0Y5tph4epfu3btnswcna1f308CR8RS4BPAWzPzhxExY9cubU9In8zcAmwBGB0dzbGxsZ5ru/gwT8XOZNOaKa7aO5wPSPdb+30Xjs1fMT1otVr089+7SdbejGGuHZqvv6+7gCLiSbT/8b8uMz9Zmg8cmtoprw+X9glgZcfbVwAP9XN8SVLv+rkLKIBrgLsz8+86Nm0HNpTlDcBNHe0XlbuBzgQOZub+Xo8vSepPP3MdLwFeD+yNiK+Xtj8DrgRuiIhLgPuB88u2HcC5wDjwGPCGPo4tSepTzwFQLubONOG/rkv/BC7t9XiSpPnlk8CSVCkDQJIqZQBIUqUMAEmqlAEgSZUazkdetSD8PGGpLo4AJKlSBoAkVcopIB2Rw00PgVNE0jByBCBJlXIEoIHwArO0+DgCkKRKOQLQvJjtGoGkxccRgCRVygCQpEoZAJJUKa8BqHGHrh9sWjPFxV2uJXiXkLQwHAFIUqUcAWjR6+cZAp9glmZmAGioefup1DungCSpUo4AVLV+RhBOH2nYDXwEEBFnR8Q9ETEeEZsHfXxJUttARwARcRTwQeB3gQngKxGxPTO/Ocg6pPnQOXqY6RbWmTh60GIw6CmgM4DxzLwXICK2AesBA0BV6efuJO9s0nwZdAAsBx7oWJ8AXjjgGqRFr59rE3N971xHL73q55ZdQ21hRGYO7mAR5wNnZeYflvXXA2dk5ps7+mwENpbV5wD3DKzAtpOA7w34mPNlmGuH4a7f2psxzLXDwtX/K5n59Nk6DXoEMAGs7FhfATzU2SEztwBbBllUp4i4PTNHmzp+P4a5dhju+q29GcNcOzRf/6DvAvoKsDoiTomIo4ELgO0DrkGSxIBHAJk5FRFvAm4BjgKuzcy7BlmDJKlt4A+CZeYOYMegjzsHjU0/zYNhrh2Gu35rb8Yw1w4N1z/Qi8CSpMXDvwUkSZWqOgAi4i0RcWdE3BURby1t74yIByPi6+Xr3KbrPCQiro2IhyPizo62EyJiZ0TsK6/Hl/aIiA+UP7lxR0Sc3lzlc659LCIOdvw3+PPmKp+x9vPLz83PI2J0Wv/Ly3m/JyLOGnzFv2gu9UfEqoh4vOPcf6iZqv+vnm61vycivlV+rj8VEcs6ti2acz+X2hs775lZ5RdwGnAn8BTa10L+DVgNvBP406brm6HmlwKnA3d2tP0NsLksbwbeXZbPBT4DBHAmcNsQ1T4GfLrp8z1L7c+l/ZxKCxjtaD8V+AZwDHAK8G3gqCGqf1Vnv6a/Zqj95cCSsvzujp+bRXXu51h7I+e95hHAc4HdmflYZk4BXwRe3XBNh5WZtwKPTGteD2wty1uB8zraP5ptu4FlEXHyYCp9ojnWvqh0qz0z787Mbg8prge2ZeZPMvM7wDjtP4HSmDnWv6jMUPvnyv+zALtpP08Ei+zcz7H2RtQcAHcCL42IEyPiKbR/Yz70kNqbyhDt2kPTEovYSGbuByivzyjt3f7sxvIB1zabmWoHeFFEfCMiPhMRz2umvJ4Mw3mfzSkR8bWI+GJE/HbTxczijbRHujB8576zdmjgvFcbAJl5N+0h2E7gs7SHjlPA1cCvAr8J7AeuaqrGPkWXtmG55eurtB9lfz7w98C/NlzPXAzzeYf2z/wzM/O3gLcB/xwRT2u4pq4i4h20/5+97lBTl26L8tx3qb2R815tAABk5jWZeXpmvpT2UG1fZh7IzJ9l5s+Bf6Th4fsROHBoaqe8PlzaZ/2zG4tA19oz84eZOVmWdwBPioiTmitzTobhvM+oTJ98vyzvoT2P/mvNVvVEEbEBeCVwYZZJdIbk3HervanzXnUARMQzyuszgd8Hrp82T/5q2lNFi9l2YENZ3gDc1NF+Ubkb6Ezg4KHplkWka+0R8csREWX5DNo/p99vpMK52w5cEBHHRMQptG8s+HLDNR2xiHh6tD+3g4h4Fu367222ql8UEWcDlwGvyszHOjYt+nM/U+2NnfemrpAvhi/g32l/FsE3gHWl7WPAXuAO2j9QJzddZ0e919MeKv4P7d92LgFOBHYB+8rrCaVv0P7wnW+X72d0iGp/E3BX+e+yG3jxIqz91WX5J8AB4JaO/u8o5/0e4JxF+nPTtX7gDzrO/VeB31uEtY/Tnuv/evn60GI893Opvanz7pPAklSpqqeAJKlmBoAkVcoAkKRKGQCSVCkDQJIqZQBIUqUMAEmqlAEgSZX6X3oi0DEL86G2AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df['积分分值'].hist(bins = 40)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "93.96\n",
      "94.5\n"
     ]
    }
   ],
   "source": [
    "print(df['积分分值'].quantile(0.10))\n",
    "print(df['积分分值'].quantile(0.25))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('积分落户.csv', encoding='gbk', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>人数</th>\n",
       "      <th>平均年龄</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>单位名称</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>北京华为数字技术有限公司</th>\n",
       "      <td>217</td>\n",
       "      <td>38.847926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中央电视台</th>\n",
       "      <td>112</td>\n",
       "      <td>42.741071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>联想（北京）有限公司</th>\n",
       "      <td>49</td>\n",
       "      <td>41.367347</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华为技术有限公司北京研究所</th>\n",
       "      <td>46</td>\n",
       "      <td>40.043478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>百度在线网络技术（北京）有限公司</th>\n",
       "      <td>44</td>\n",
       "      <td>38.522727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京外企人力资源服务有限公司</th>\n",
       "      <td>43</td>\n",
       "      <td>41.604651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国石油天然气股份有限公司管道北京输油气分公司</th>\n",
       "      <td>41</td>\n",
       "      <td>44.463415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京首钢建设集团有限公司</th>\n",
       "      <td>34</td>\n",
       "      <td>44.205882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>腾讯科技（北京）有限公司</th>\n",
       "      <td>33</td>\n",
       "      <td>39.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国国际技术智力合作有限公司</th>\n",
       "      <td>29</td>\n",
       "      <td>42.068966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国民生银行股份有限公司</th>\n",
       "      <td>27</td>\n",
       "      <td>40.851852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国际商业机器（中国）投资有限公司</th>\n",
       "      <td>26</td>\n",
       "      <td>40.846154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>阿里巴巴（北京）软件服务有限公司</th>\n",
       "      <td>23</td>\n",
       "      <td>39.826087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中铁电气化局集团有限公司城铁公司</th>\n",
       "      <td>21</td>\n",
       "      <td>45.238095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>微软（中国）有限公司</th>\n",
       "      <td>20</td>\n",
       "      <td>41.950000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中铁三局集团第四工程有限公司</th>\n",
       "      <td>20</td>\n",
       "      <td>42.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中煤建设集团工程有限公司</th>\n",
       "      <td>19</td>\n",
       "      <td>45.473684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>爱立信（中国）通信有限公司</th>\n",
       "      <td>18</td>\n",
       "      <td>42.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国铁路北京局集团有限公司北京大型养路机械运用检修段</th>\n",
       "      <td>18</td>\n",
       "      <td>43.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京中铁隧建筑有限公司</th>\n",
       "      <td>18</td>\n",
       "      <td>43.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中建二局安装工程有限公司</th>\n",
       "      <td>17</td>\n",
       "      <td>45.294118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中铁建工集团有限公司</th>\n",
       "      <td>16</td>\n",
       "      <td>44.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京京东尚科信息技术有限公司</th>\n",
       "      <td>15</td>\n",
       "      <td>40.066667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新华三技术有限公司北京研究所</th>\n",
       "      <td>14</td>\n",
       "      <td>40.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>诺基亚通信系统技术（北京）有限公司</th>\n",
       "      <td>14</td>\n",
       "      <td>42.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京三快在线科技有限公司</th>\n",
       "      <td>13</td>\n",
       "      <td>38.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>阿里巴巴科技（北京）有限公司</th>\n",
       "      <td>13</td>\n",
       "      <td>40.615385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国石油天然气股份有限公司北京销售分公司</th>\n",
       "      <td>13</td>\n",
       "      <td>44.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国际商业机器（中国）有限公司北京分公司</th>\n",
       "      <td>13</td>\n",
       "      <td>42.461538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中铁电气化局集团第一工程有限公司</th>\n",
       "      <td>12</td>\n",
       "      <td>45.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京奥雅洛嘉图文设计服务有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>42.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京好伦哥餐饮有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>43.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京威克多制衣中心</th>\n",
       "      <td>1</td>\n",
       "      <td>46.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天聚盛世人力资源管理有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>41.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天美高新科学仪器有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>37.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天一国际广告有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>41.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天华嵌微信息技术有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>45.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天九幸福投资顾问有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>43.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天亿联横新技术有限责任公司</th>\n",
       "      <td>1</td>\n",
       "      <td>45.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天信致远数据信息技术有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>43.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天信顺达咨询有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>43.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天元特通科技有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>37.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天兴陶瓷复合材料有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>44.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天凯华尊科技有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>45.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天创弘河科技有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>43.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天创金农科技有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>44.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天勤久盛科技有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>47.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天合永誉商贸有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>43.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天溪晨泽商贸有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>42.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天哲消失模铸造技术有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>47.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天地怡宝科技有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>43.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天天乐学教育科技有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>44.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天安车云科技有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>40.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天尧信息技术有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>44.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天择思特科技有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>47.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天泽鸿吉文化传媒有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>39.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天洋科技有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>45.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天润科丰科技有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>45.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京天源科创风电技术有限责任公司</th>\n",
       "      <td>1</td>\n",
       "      <td>38.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ＳＥＷ—传动设备（天津）有限公司北京分公司</th>\n",
       "      <td>1</td>\n",
       "      <td>41.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3714 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             人数       平均年龄\n",
       "单位名称                                      \n",
       "北京华为数字技术有限公司                217  38.847926\n",
       "中央电视台                       112  42.741071\n",
       "联想（北京）有限公司                   49  41.367347\n",
       "华为技术有限公司北京研究所                46  40.043478\n",
       "百度在线网络技术（北京）有限公司             44  38.522727\n",
       "北京外企人力资源服务有限公司               43  41.604651\n",
       "中国石油天然气股份有限公司管道北京输油气分公司      41  44.463415\n",
       "北京首钢建设集团有限公司                 34  44.205882\n",
       "腾讯科技（北京）有限公司                 33  39.666667\n",
       "中国国际技术智力合作有限公司               29  42.068966\n",
       "中国民生银行股份有限公司                 27  40.851852\n",
       "国际商业机器（中国）投资有限公司             26  40.846154\n",
       "阿里巴巴（北京）软件服务有限公司             23  39.826087\n",
       "中铁电气化局集团有限公司城铁公司             21  45.238095\n",
       "微软（中国）有限公司                   20  41.950000\n",
       "中铁三局集团第四工程有限公司               20  42.750000\n",
       "中煤建设集团工程有限公司                 19  45.473684\n",
       "爱立信（中国）通信有限公司                18  42.333333\n",
       "中国铁路北京局集团有限公司北京大型养路机械运用检修段   18  43.777778\n",
       "北京中铁隧建筑有限公司                  18  43.500000\n",
       "中建二局安装工程有限公司                 17  45.294118\n",
       "中铁建工集团有限公司                   16  44.500000\n",
       "北京京东尚科信息技术有限公司               15  40.066667\n",
       "新华三技术有限公司北京研究所               14  40.428571\n",
       "诺基亚通信系统技术（北京）有限公司            14  42.571429\n",
       "北京三快在线科技有限公司                 13  38.000000\n",
       "阿里巴巴科技（北京）有限公司               13  40.615385\n",
       "中国石油天然气股份有限公司北京销售分公司         13  44.076923\n",
       "国际商业机器（中国）有限公司北京分公司          13  42.461538\n",
       "中铁电气化局集团第一工程有限公司             12  45.000000\n",
       "...                         ...        ...\n",
       "北京奥雅洛嘉图文设计服务有限公司              1  42.000000\n",
       "北京好伦哥餐饮有限公司                   1  43.000000\n",
       "北京威克多制衣中心                     1  46.000000\n",
       "北京天聚盛世人力资源管理有限公司              1  41.000000\n",
       "北京天美高新科学仪器有限公司                1  37.000000\n",
       "北京天一国际广告有限公司                  1  41.000000\n",
       "北京天华嵌微信息技术有限公司                1  45.000000\n",
       "北京天九幸福投资顾问有限公司                1  43.000000\n",
       "北京天亿联横新技术有限责任公司               1  45.000000\n",
       "北京天信致远数据信息技术有限公司              1  43.000000\n",
       "北京天信顺达咨询有限公司                  1  43.000000\n",
       "北京天元特通科技有限公司                  1  37.000000\n",
       "北京天兴陶瓷复合材料有限公司                1  44.000000\n",
       "北京天凯华尊科技有限公司                  1  45.000000\n",
       "北京天创弘河科技有限公司                  1  43.000000\n",
       "北京天创金农科技有限公司                  1  44.000000\n",
       "北京天勤久盛科技有限公司                  1  47.000000\n",
       "北京天合永誉商贸有限公司                  1  43.000000\n",
       "北京天溪晨泽商贸有限公司                  1  42.000000\n",
       "北京天哲消失模铸造技术有限公司               1  47.000000\n",
       "北京天地怡宝科技有限公司                  1  43.000000\n",
       "北京天天乐学教育科技有限公司                1  44.000000\n",
       "北京天安车云科技有限公司                  1  40.000000\n",
       "北京天尧信息技术有限公司                  1  44.000000\n",
       "北京天择思特科技有限公司                  1  47.000000\n",
       "北京天泽鸿吉文化传媒有限公司                1  39.000000\n",
       "北京天洋科技有限公司                    1  45.000000\n",
       "北京天润科丰科技有限公司                  1  45.000000\n",
       "北京天源科创风电技术有限责任公司              1  38.000000\n",
       "ＳＥＷ—传动设备（天津）有限公司北京分公司         1  41.000000\n",
       "\n",
       "[3714 rows x 2 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gp = df.groupby('单位名称')\n",
    "danwei_df = pd.DataFrame({'人数':gp.size(),'平均年龄':gp['age'].mean()})\n",
    "danwei_df.sort_values('人数', ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>序号</th>\n",
       "      <th>姓名</th>\n",
       "      <th>出生年月</th>\n",
       "      <th>单位名称</th>\n",
       "      <th>积分分值</th>\n",
       "      <th>year</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>序号</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3485</th>\n",
       "      <td>3485</td>\n",
       "      <td>江畅</td>\n",
       "      <td>1987-05</td>\n",
       "      <td>百度在线网络技术（北京）有限公司</td>\n",
       "      <td>95.62</td>\n",
       "      <td>1987</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1719</th>\n",
       "      <td>1719</td>\n",
       "      <td>邵伟</td>\n",
       "      <td>1986-04</td>\n",
       "      <td>北京华为数字技术有限公司</td>\n",
       "      <td>98.75</td>\n",
       "      <td>1986</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4856</th>\n",
       "      <td>4856</td>\n",
       "      <td>涂玲珑</td>\n",
       "      <td>1985-05</td>\n",
       "      <td>北京华为数字技术有限公司</td>\n",
       "      <td>94.29</td>\n",
       "      <td>1985</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4568</th>\n",
       "      <td>4568</td>\n",
       "      <td>张博</td>\n",
       "      <td>1985-03</td>\n",
       "      <td>北京银龙知识产权代理有限公司</td>\n",
       "      <td>94.50</td>\n",
       "      <td>1985</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5919</th>\n",
       "      <td>5919</td>\n",
       "      <td>毛兆亮</td>\n",
       "      <td>1985-03</td>\n",
       "      <td>北京丽泽金融商务区控股有限公司</td>\n",
       "      <td>93.63</td>\n",
       "      <td>1985</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4329</th>\n",
       "      <td>4329</td>\n",
       "      <td>程军</td>\n",
       "      <td>1985-08</td>\n",
       "      <td>百度在线网络技术（北京）有限公司</td>\n",
       "      <td>94.66</td>\n",
       "      <td>1985</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5430</th>\n",
       "      <td>5430</td>\n",
       "      <td>洪炳峰</td>\n",
       "      <td>1985-02</td>\n",
       "      <td>北京奇艺世纪科技有限公司</td>\n",
       "      <td>93.92</td>\n",
       "      <td>1985</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2104</th>\n",
       "      <td>2104</td>\n",
       "      <td>唐本莹</td>\n",
       "      <td>1985-11</td>\n",
       "      <td>北京华为数字技术有限公司</td>\n",
       "      <td>97.91</td>\n",
       "      <td>1985</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4765</th>\n",
       "      <td>4765</td>\n",
       "      <td>王军</td>\n",
       "      <td>1985-07</td>\n",
       "      <td>百度在线网络技术（北京）有限公司</td>\n",
       "      <td>94.34</td>\n",
       "      <td>1985</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2218</th>\n",
       "      <td>2218</td>\n",
       "      <td>黄铄钧</td>\n",
       "      <td>1984-07</td>\n",
       "      <td>韬睿惠悦管理咨询（深圳）有限公司北京分公司</td>\n",
       "      <td>97.67</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3812</th>\n",
       "      <td>3812</td>\n",
       "      <td>赵元凤</td>\n",
       "      <td>1984-01</td>\n",
       "      <td>北京华为数字技术有限公司</td>\n",
       "      <td>95.13</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3592</th>\n",
       "      <td>3592</td>\n",
       "      <td>郭佳春</td>\n",
       "      <td>1984-07</td>\n",
       "      <td>北京华为数字技术有限公司</td>\n",
       "      <td>95.46</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3037</th>\n",
       "      <td>3037</td>\n",
       "      <td>安志炜</td>\n",
       "      <td>1984-09</td>\n",
       "      <td>中国机械设备工程股份有限公司</td>\n",
       "      <td>96.21</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5149</th>\n",
       "      <td>5149</td>\n",
       "      <td>肖丽萍</td>\n",
       "      <td>1984-05</td>\n",
       "      <td>光控安石（北京）投资管理有限公司</td>\n",
       "      <td>94.12</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2708</th>\n",
       "      <td>2708</td>\n",
       "      <td>张朋</td>\n",
       "      <td>1984-11</td>\n",
       "      <td>北京华为数字技术有限公司</td>\n",
       "      <td>96.75</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2691</th>\n",
       "      <td>2691</td>\n",
       "      <td>张梦晗</td>\n",
       "      <td>1984-07</td>\n",
       "      <td>北京华为数字技术有限公司</td>\n",
       "      <td>96.79</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5235</th>\n",
       "      <td>5235</td>\n",
       "      <td>罗京</td>\n",
       "      <td>1984-02</td>\n",
       "      <td>北京搜狗网络技术有限公司</td>\n",
       "      <td>94.05</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2668</th>\n",
       "      <td>2668</td>\n",
       "      <td>于庆</td>\n",
       "      <td>1984-10</td>\n",
       "      <td>北京奇艺世纪科技有限公司</td>\n",
       "      <td>96.83</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4071</th>\n",
       "      <td>4071</td>\n",
       "      <td>王巍巍</td>\n",
       "      <td>1984-09</td>\n",
       "      <td>百度在线网络技术（北京）有限公司</td>\n",
       "      <td>94.84</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3875</th>\n",
       "      <td>3875</td>\n",
       "      <td>杨定国</td>\n",
       "      <td>1984-03</td>\n",
       "      <td>北京华为数字技术有限公司</td>\n",
       "      <td>95.08</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2912</th>\n",
       "      <td>2912</td>\n",
       "      <td>王海威</td>\n",
       "      <td>1984-10</td>\n",
       "      <td>百度时代网络技术（北京）有限公司</td>\n",
       "      <td>96.41</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4149</th>\n",
       "      <td>4149</td>\n",
       "      <td>李磊</td>\n",
       "      <td>1984-02</td>\n",
       "      <td>北京华为数字技术有限公司</td>\n",
       "      <td>94.76</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1095</th>\n",
       "      <td>1095</td>\n",
       "      <td>蒋南頔</td>\n",
       "      <td>1984-10</td>\n",
       "      <td>北京市路盛律师事务所</td>\n",
       "      <td>100.46</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3460</th>\n",
       "      <td>3460</td>\n",
       "      <td>胡瑾英</td>\n",
       "      <td>1984-06</td>\n",
       "      <td>优视科技有限公司</td>\n",
       "      <td>95.63</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5680</th>\n",
       "      <td>5680</td>\n",
       "      <td>李涛</td>\n",
       "      <td>1984-05</td>\n",
       "      <td>百度在线网络技术（北京）有限公司</td>\n",
       "      <td>93.75</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3149</th>\n",
       "      <td>3149</td>\n",
       "      <td>刘瑞冬</td>\n",
       "      <td>1984-01</td>\n",
       "      <td>高德软件有限公司</td>\n",
       "      <td>96.04</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3432</th>\n",
       "      <td>3432</td>\n",
       "      <td>张随兵</td>\n",
       "      <td>1984-10</td>\n",
       "      <td>高德软件有限公司</td>\n",
       "      <td>95.67</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5829</th>\n",
       "      <td>5829</td>\n",
       "      <td>王全修</td>\n",
       "      <td>1984-09</td>\n",
       "      <td>北京睿企信息科技有限公司</td>\n",
       "      <td>93.67</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4636</th>\n",
       "      <td>4636</td>\n",
       "      <td>姚春念</td>\n",
       "      <td>1984-04</td>\n",
       "      <td>优视科技有限公司</td>\n",
       "      <td>94.42</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4612</th>\n",
       "      <td>4612</td>\n",
       "      <td>杨月奎</td>\n",
       "      <td>1984-05</td>\n",
       "      <td>腾讯科技（北京）有限公司</td>\n",
       "      <td>94.46</td>\n",
       "      <td>1984</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5786</th>\n",
       "      <td>5786</td>\n",
       "      <td>田学斌</td>\n",
       "      <td>1967-11</td>\n",
       "      <td>北京首钢建设集团有限公司</td>\n",
       "      <td>93.71</td>\n",
       "      <td>1967</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2643</th>\n",
       "      <td>2643</td>\n",
       "      <td>曹力</td>\n",
       "      <td>1967-03</td>\n",
       "      <td>中铁电气化局集团物资贸易有限公司</td>\n",
       "      <td>96.84</td>\n",
       "      <td>1967</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2814</th>\n",
       "      <td>2814</td>\n",
       "      <td>张骁</td>\n",
       "      <td>1967-10</td>\n",
       "      <td>中视前卫影视传媒有限公司</td>\n",
       "      <td>96.58</td>\n",
       "      <td>1967</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5323</th>\n",
       "      <td>5323</td>\n",
       "      <td>张巧芬</td>\n",
       "      <td>1966-01</td>\n",
       "      <td>中国建筑第二工程局有限公司总承包公司</td>\n",
       "      <td>94.00</td>\n",
       "      <td>1966</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3685</th>\n",
       "      <td>3685</td>\n",
       "      <td>刘斌</td>\n",
       "      <td>1966-02</td>\n",
       "      <td>北京中建地产有限责任公司</td>\n",
       "      <td>95.34</td>\n",
       "      <td>1966</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2677</th>\n",
       "      <td>2677</td>\n",
       "      <td>孙学瑞</td>\n",
       "      <td>1966-07</td>\n",
       "      <td>爱科斯福通信技术（北京）有限公司</td>\n",
       "      <td>96.79</td>\n",
       "      <td>1966</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3472</th>\n",
       "      <td>3472</td>\n",
       "      <td>许友群</td>\n",
       "      <td>1966-10</td>\n",
       "      <td>中铁电气化局集团有限公司城铁公司</td>\n",
       "      <td>95.63</td>\n",
       "      <td>1966</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1648</th>\n",
       "      <td>1648</td>\n",
       "      <td>郑珊</td>\n",
       "      <td>1966-09</td>\n",
       "      <td>中国建筑第二工程局有限公司总承包公司</td>\n",
       "      <td>98.91</td>\n",
       "      <td>1966</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2294</th>\n",
       "      <td>2294</td>\n",
       "      <td>邢志勇</td>\n",
       "      <td>1965-01</td>\n",
       "      <td>中铁电气化局集团第一工程有限公司</td>\n",
       "      <td>97.54</td>\n",
       "      <td>1965</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>707</th>\n",
       "      <td>707</td>\n",
       "      <td>杨永松</td>\n",
       "      <td>1965-12</td>\n",
       "      <td>北京英思杰科技有限公司</td>\n",
       "      <td>102.04</td>\n",
       "      <td>1965</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4731</th>\n",
       "      <td>4731</td>\n",
       "      <td>孔庆利</td>\n",
       "      <td>1965-11</td>\n",
       "      <td>通用电气石油天然气设备（北京）有限公司</td>\n",
       "      <td>94.37</td>\n",
       "      <td>1965</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>99</td>\n",
       "      <td>卢拥军</td>\n",
       "      <td>1965-02</td>\n",
       "      <td>中国石油天然气股份有限公司勘探开发研究院</td>\n",
       "      <td>109.41</td>\n",
       "      <td>1965</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>869</th>\n",
       "      <td>869</td>\n",
       "      <td>熊汉忠</td>\n",
       "      <td>1965-05</td>\n",
       "      <td>北京市通州区大家心理服务中心</td>\n",
       "      <td>101.21</td>\n",
       "      <td>1965</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651</th>\n",
       "      <td>1651</td>\n",
       "      <td>郝建亚</td>\n",
       "      <td>1965-03</td>\n",
       "      <td>北京市鑫诺律师事务所</td>\n",
       "      <td>98.91</td>\n",
       "      <td>1965</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4610</th>\n",
       "      <td>4610</td>\n",
       "      <td>张健</td>\n",
       "      <td>1965-02</td>\n",
       "      <td>北京捷安特技术服务有限公司</td>\n",
       "      <td>94.46</td>\n",
       "      <td>1965</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5750</th>\n",
       "      <td>5750</td>\n",
       "      <td>彭顺喜</td>\n",
       "      <td>1965-01</td>\n",
       "      <td>通用电气石油天然气设备（北京）有限公司</td>\n",
       "      <td>93.71</td>\n",
       "      <td>1965</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5989</th>\n",
       "      <td>5989</td>\n",
       "      <td>姜树道</td>\n",
       "      <td>1965-09</td>\n",
       "      <td>中冶赛迪电气技术有限公司</td>\n",
       "      <td>93.58</td>\n",
       "      <td>1965</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3323</th>\n",
       "      <td>3323</td>\n",
       "      <td>孙颖奇</td>\n",
       "      <td>1964-10</td>\n",
       "      <td>北京爱地地质勘察基础工程公司</td>\n",
       "      <td>95.79</td>\n",
       "      <td>1964</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1801</th>\n",
       "      <td>1801</td>\n",
       "      <td>郑志刚</td>\n",
       "      <td>1964-03</td>\n",
       "      <td>国科创新科技园发展有限公司</td>\n",
       "      <td>98.59</td>\n",
       "      <td>1964</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3250</th>\n",
       "      <td>3250</td>\n",
       "      <td>吴文君</td>\n",
       "      <td>1964-09</td>\n",
       "      <td>中建二局安装工程有限公司</td>\n",
       "      <td>95.91</td>\n",
       "      <td>1964</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>840</th>\n",
       "      <td>840</td>\n",
       "      <td>王宁</td>\n",
       "      <td>1964-07</td>\n",
       "      <td>易安信电脑系统（中国）有限公司</td>\n",
       "      <td>101.29</td>\n",
       "      <td>1964</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2612</th>\n",
       "      <td>2612</td>\n",
       "      <td>庞惠德</td>\n",
       "      <td>1964-10</td>\n",
       "      <td>中国建筑第二工程局有限公司总承包公司</td>\n",
       "      <td>96.91</td>\n",
       "      <td>1964</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1490</th>\n",
       "      <td>1490</td>\n",
       "      <td>李小梅</td>\n",
       "      <td>1964-01</td>\n",
       "      <td>西赛尔(北京)科技发展有限公司</td>\n",
       "      <td>99.33</td>\n",
       "      <td>1964</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3977</th>\n",
       "      <td>3977</td>\n",
       "      <td>卢百华</td>\n",
       "      <td>1963-10</td>\n",
       "      <td>中国建筑第二工程局有限公司总承包公司</td>\n",
       "      <td>94.96</td>\n",
       "      <td>1963</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3213</th>\n",
       "      <td>3213</td>\n",
       "      <td>范泽</td>\n",
       "      <td>1963-12</td>\n",
       "      <td>维美德（中国）有限公司北京分公司</td>\n",
       "      <td>95.96</td>\n",
       "      <td>1963</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5309</th>\n",
       "      <td>5309</td>\n",
       "      <td>杨松</td>\n",
       "      <td>1962-10</td>\n",
       "      <td>中国石油集团工程技术研究院有限公司</td>\n",
       "      <td>94.00</td>\n",
       "      <td>1962</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3847</th>\n",
       "      <td>3847</td>\n",
       "      <td>魏雄志</td>\n",
       "      <td>1962-10</td>\n",
       "      <td>波音（中国）投资有限公司</td>\n",
       "      <td>95.09</td>\n",
       "      <td>1962</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1228</th>\n",
       "      <td>1228</td>\n",
       "      <td>张弛</td>\n",
       "      <td>1961-11</td>\n",
       "      <td>北京尚驰环球建筑设计事务所（普通合伙）</td>\n",
       "      <td>100.04</td>\n",
       "      <td>1961</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>334</th>\n",
       "      <td>334</td>\n",
       "      <td>李庭祥</td>\n",
       "      <td>1960-06</td>\n",
       "      <td>北京首嘉钢结构有限公司</td>\n",
       "      <td>105.04</td>\n",
       "      <td>1960</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5865</th>\n",
       "      <td>5865</td>\n",
       "      <td>郭宝军</td>\n",
       "      <td>1959-05</td>\n",
       "      <td>北京国华电力有限责任公司</td>\n",
       "      <td>93.66</td>\n",
       "      <td>1959</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6007 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        序号   姓名     出生年月                   单位名称    积分分值  year  age\n",
       "序号                                                                \n",
       "3485  3485   江畅  1987-05       百度在线网络技术（北京）有限公司   95.62  1987   32\n",
       "1719  1719   邵伟  1986-04           北京华为数字技术有限公司   98.75  1986   33\n",
       "4856  4856  涂玲珑  1985-05           北京华为数字技术有限公司   94.29  1985   34\n",
       "4568  4568   张博  1985-03         北京银龙知识产权代理有限公司   94.50  1985   34\n",
       "5919  5919  毛兆亮  1985-03        北京丽泽金融商务区控股有限公司   93.63  1985   34\n",
       "4329  4329   程军  1985-08       百度在线网络技术（北京）有限公司   94.66  1985   34\n",
       "5430  5430  洪炳峰  1985-02           北京奇艺世纪科技有限公司   93.92  1985   34\n",
       "2104  2104  唐本莹  1985-11           北京华为数字技术有限公司   97.91  1985   34\n",
       "4765  4765   王军  1985-07       百度在线网络技术（北京）有限公司   94.34  1985   34\n",
       "2218  2218  黄铄钧  1984-07  韬睿惠悦管理咨询（深圳）有限公司北京分公司   97.67  1984   35\n",
       "3812  3812  赵元凤  1984-01           北京华为数字技术有限公司   95.13  1984   35\n",
       "3592  3592  郭佳春  1984-07           北京华为数字技术有限公司   95.46  1984   35\n",
       "3037  3037  安志炜  1984-09         中国机械设备工程股份有限公司   96.21  1984   35\n",
       "5149  5149  肖丽萍  1984-05       光控安石（北京）投资管理有限公司   94.12  1984   35\n",
       "2708  2708   张朋  1984-11           北京华为数字技术有限公司   96.75  1984   35\n",
       "2691  2691  张梦晗  1984-07           北京华为数字技术有限公司   96.79  1984   35\n",
       "5235  5235   罗京  1984-02           北京搜狗网络技术有限公司   94.05  1984   35\n",
       "2668  2668   于庆  1984-10           北京奇艺世纪科技有限公司   96.83  1984   35\n",
       "4071  4071  王巍巍  1984-09       百度在线网络技术（北京）有限公司   94.84  1984   35\n",
       "3875  3875  杨定国  1984-03           北京华为数字技术有限公司   95.08  1984   35\n",
       "2912  2912  王海威  1984-10       百度时代网络技术（北京）有限公司   96.41  1984   35\n",
       "4149  4149   李磊  1984-02           北京华为数字技术有限公司   94.76  1984   35\n",
       "1095  1095  蒋南頔  1984-10             北京市路盛律师事务所  100.46  1984   35\n",
       "3460  3460  胡瑾英  1984-06               优视科技有限公司   95.63  1984   35\n",
       "5680  5680   李涛  1984-05       百度在线网络技术（北京）有限公司   93.75  1984   35\n",
       "3149  3149  刘瑞冬  1984-01               高德软件有限公司   96.04  1984   35\n",
       "3432  3432  张随兵  1984-10               高德软件有限公司   95.67  1984   35\n",
       "5829  5829  王全修  1984-09           北京睿企信息科技有限公司   93.67  1984   35\n",
       "4636  4636  姚春念  1984-04               优视科技有限公司   94.42  1984   35\n",
       "4612  4612  杨月奎  1984-05           腾讯科技（北京）有限公司   94.46  1984   35\n",
       "...    ...  ...      ...                    ...     ...   ...  ...\n",
       "5786  5786  田学斌  1967-11           北京首钢建设集团有限公司   93.71  1967   52\n",
       "2643  2643   曹力  1967-03       中铁电气化局集团物资贸易有限公司   96.84  1967   52\n",
       "2814  2814   张骁  1967-10           中视前卫影视传媒有限公司   96.58  1967   52\n",
       "5323  5323  张巧芬  1966-01     中国建筑第二工程局有限公司总承包公司   94.00  1966   53\n",
       "3685  3685   刘斌  1966-02           北京中建地产有限责任公司   95.34  1966   53\n",
       "2677  2677  孙学瑞  1966-07       爱科斯福通信技术（北京）有限公司   96.79  1966   53\n",
       "3472  3472  许友群  1966-10       中铁电气化局集团有限公司城铁公司   95.63  1966   53\n",
       "1648  1648   郑珊  1966-09     中国建筑第二工程局有限公司总承包公司   98.91  1966   53\n",
       "2294  2294  邢志勇  1965-01       中铁电气化局集团第一工程有限公司   97.54  1965   54\n",
       "707    707  杨永松  1965-12            北京英思杰科技有限公司  102.04  1965   54\n",
       "4731  4731  孔庆利  1965-11    通用电气石油天然气设备（北京）有限公司   94.37  1965   54\n",
       "99      99  卢拥军  1965-02   中国石油天然气股份有限公司勘探开发研究院  109.41  1965   54\n",
       "869    869  熊汉忠  1965-05         北京市通州区大家心理服务中心  101.21  1965   54\n",
       "1651  1651  郝建亚  1965-03             北京市鑫诺律师事务所   98.91  1965   54\n",
       "4610  4610   张健  1965-02          北京捷安特技术服务有限公司   94.46  1965   54\n",
       "5750  5750  彭顺喜  1965-01    通用电气石油天然气设备（北京）有限公司   93.71  1965   54\n",
       "5989  5989  姜树道  1965-09           中冶赛迪电气技术有限公司   93.58  1965   54\n",
       "3323  3323  孙颖奇  1964-10         北京爱地地质勘察基础工程公司   95.79  1964   55\n",
       "1801  1801  郑志刚  1964-03          国科创新科技园发展有限公司   98.59  1964   55\n",
       "3250  3250  吴文君  1964-09           中建二局安装工程有限公司   95.91  1964   55\n",
       "840    840   王宁  1964-07        易安信电脑系统（中国）有限公司  101.29  1964   55\n",
       "2612  2612  庞惠德  1964-10     中国建筑第二工程局有限公司总承包公司   96.91  1964   55\n",
       "1490  1490  李小梅  1964-01        西赛尔(北京)科技发展有限公司   99.33  1964   55\n",
       "3977  3977  卢百华  1963-10     中国建筑第二工程局有限公司总承包公司   94.96  1963   56\n",
       "3213  3213   范泽  1963-12       维美德（中国）有限公司北京分公司   95.96  1963   56\n",
       "5309  5309   杨松  1962-10      中国石油集团工程技术研究院有限公司   94.00  1962   57\n",
       "3847  3847  魏雄志  1962-10           波音（中国）投资有限公司   95.09  1962   57\n",
       "1228  1228   张弛  1961-11    北京尚驰环球建筑设计事务所（普通合伙）  100.04  1961   58\n",
       "334    334  李庭祥  1960-06            北京首嘉钢结构有限公司  105.04  1960   59\n",
       "5865  5865  郭宝军  1959-05           北京国华电力有限责任公司   93.66  1959   60\n",
       "\n",
       "[6007 rows x 7 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values('age')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "42.01847844181788"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['age'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "17\n",
      "43.294117647058826\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>序号</th>\n",
       "      <th>姓名</th>\n",
       "      <th>出生年月</th>\n",
       "      <th>单位名称</th>\n",
       "      <th>积分分值</th>\n",
       "      <th>year</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>序号</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>464</th>\n",
       "      <td>464</td>\n",
       "      <td>王雪英</td>\n",
       "      <td>1975-11</td>\n",
       "      <td>北京肿瘤医院</td>\n",
       "      <td>103.96</td>\n",
       "      <td>1975</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>577</th>\n",
       "      <td>577</td>\n",
       "      <td>张宇晖</td>\n",
       "      <td>1975-10</td>\n",
       "      <td>北京高博医院管理有限公司</td>\n",
       "      <td>102.92</td>\n",
       "      <td>1975</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>631</th>\n",
       "      <td>631</td>\n",
       "      <td>赵文惠</td>\n",
       "      <td>1973-01</td>\n",
       "      <td>北京肿瘤医院</td>\n",
       "      <td>102.55</td>\n",
       "      <td>1973</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>794</td>\n",
       "      <td>戴武兵</td>\n",
       "      <td>1972-01</td>\n",
       "      <td>北京京通医院</td>\n",
       "      <td>101.54</td>\n",
       "      <td>1972</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>926</th>\n",
       "      <td>926</td>\n",
       "      <td>张冬青</td>\n",
       "      <td>1974-09</td>\n",
       "      <td>北京美中爱瑞肿瘤医院有限责任公司</td>\n",
       "      <td>101.04</td>\n",
       "      <td>1974</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1124</th>\n",
       "      <td>1124</td>\n",
       "      <td>林楠</td>\n",
       "      <td>1976-11</td>\n",
       "      <td>北京大学国际医院</td>\n",
       "      <td>100.34</td>\n",
       "      <td>1976</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1747</th>\n",
       "      <td>1747</td>\n",
       "      <td>杨健</td>\n",
       "      <td>1974-03</td>\n",
       "      <td>泰禾医院管理有限公司</td>\n",
       "      <td>98.67</td>\n",
       "      <td>1974</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1765</th>\n",
       "      <td>1765</td>\n",
       "      <td>刘旺霞</td>\n",
       "      <td>1974-02</td>\n",
       "      <td>北京市大兴区中西医结合医院</td>\n",
       "      <td>98.67</td>\n",
       "      <td>1974</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1914</th>\n",
       "      <td>1914</td>\n",
       "      <td>徐华勇</td>\n",
       "      <td>1979-08</td>\n",
       "      <td>北京普祥医院投资管理有限公司</td>\n",
       "      <td>98.33</td>\n",
       "      <td>1979</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2249</th>\n",
       "      <td>2249</td>\n",
       "      <td>任振学</td>\n",
       "      <td>1975-06</td>\n",
       "      <td>北京弘医堂中医医院有限责任公司</td>\n",
       "      <td>97.62</td>\n",
       "      <td>1975</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2261</th>\n",
       "      <td>2261</td>\n",
       "      <td>郭玉峰</td>\n",
       "      <td>1977-01</td>\n",
       "      <td>北京和睦家医院有限公司</td>\n",
       "      <td>97.59</td>\n",
       "      <td>1977</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3936</th>\n",
       "      <td>3936</td>\n",
       "      <td>皮菊菊</td>\n",
       "      <td>1982-11</td>\n",
       "      <td>北京新安贞医院投资管理有限公司</td>\n",
       "      <td>95.00</td>\n",
       "      <td>1982</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4116</th>\n",
       "      <td>4116</td>\n",
       "      <td>谷群英</td>\n",
       "      <td>1972-01</td>\n",
       "      <td>北京市中西医结合医院</td>\n",
       "      <td>94.80</td>\n",
       "      <td>1972</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4321</th>\n",
       "      <td>4321</td>\n",
       "      <td>张晶华</td>\n",
       "      <td>1976-11</td>\n",
       "      <td>北京市健宫医院有限公司</td>\n",
       "      <td>94.66</td>\n",
       "      <td>1976</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5100</th>\n",
       "      <td>5100</td>\n",
       "      <td>冀香芹</td>\n",
       "      <td>1975-03</td>\n",
       "      <td>北京和睦家医院有限公司</td>\n",
       "      <td>94.13</td>\n",
       "      <td>1975</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5851</th>\n",
       "      <td>5851</td>\n",
       "      <td>刘佳音</td>\n",
       "      <td>1980-08</td>\n",
       "      <td>北京新里程肿瘤医院有限公司</td>\n",
       "      <td>93.67</td>\n",
       "      <td>1980</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5936</th>\n",
       "      <td>5936</td>\n",
       "      <td>何生奇</td>\n",
       "      <td>1978-02</td>\n",
       "      <td>中国中医科学院望京医院</td>\n",
       "      <td>93.62</td>\n",
       "      <td>1978</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        序号   姓名     出生年月              单位名称    积分分值  year  age\n",
       "序号                                                           \n",
       "464    464  王雪英  1975-11            北京肿瘤医院  103.96  1975   44\n",
       "577    577  张宇晖  1975-10      北京高博医院管理有限公司  102.92  1975   44\n",
       "631    631  赵文惠  1973-01            北京肿瘤医院  102.55  1973   46\n",
       "794    794  戴武兵  1972-01            北京京通医院  101.54  1972   47\n",
       "926    926  张冬青  1974-09  北京美中爱瑞肿瘤医院有限责任公司  101.04  1974   45\n",
       "1124  1124   林楠  1976-11          北京大学国际医院  100.34  1976   43\n",
       "1747  1747   杨健  1974-03        泰禾医院管理有限公司   98.67  1974   45\n",
       "1765  1765  刘旺霞  1974-02     北京市大兴区中西医结合医院   98.67  1974   45\n",
       "1914  1914  徐华勇  1979-08    北京普祥医院投资管理有限公司   98.33  1979   40\n",
       "2249  2249  任振学  1975-06   北京弘医堂中医医院有限责任公司   97.62  1975   44\n",
       "2261  2261  郭玉峰  1977-01       北京和睦家医院有限公司   97.59  1977   42\n",
       "3936  3936  皮菊菊  1982-11   北京新安贞医院投资管理有限公司   95.00  1982   37\n",
       "4116  4116  谷群英  1972-01        北京市中西医结合医院   94.80  1972   47\n",
       "4321  4321  张晶华  1976-11       北京市健宫医院有限公司   94.66  1976   43\n",
       "5100  5100  冀香芹  1975-03       北京和睦家医院有限公司   94.13  1975   44\n",
       "5851  5851  刘佳音  1980-08     北京新里程肿瘤医院有限公司   93.67  1980   39\n",
       "5936  5936  何生奇  1978-02       中国中医科学院望京医院   93.62  1978   41"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "yiyuan= df.loc[df['单位名称'].str.contains('医院')]\n",
    "print(len(yiyuan))\n",
    "print(yiyuan['age'].mean())\n",
    "display(yiyuan)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
